USE [MusicLine]
GO

CREATE PROCEDURE LookupCutsByAlbum
    @AlbumId int
AS
    SELECT  C.AlbumId, C.CutNumber, C.Title, C.LengthInSeconds
    FROM    Cuts C
    INNER JOIN Albums A ON A.AlbumId=C.AlbumId
    WHERE   A.AlbumId = @AlbumId